package com.topisv.tms.repository.edb;

import java.util.List;

import org.springframework.data.jpa.repository.JpaSpecificationExecutor;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.PagingAndSortingRepository;

import com.topisv.tms.entity.edb.EdbTask;
import com.topisv.tms.entity.task.MdSendOutTask;

public interface EdbTaskDao extends PagingAndSortingRepository<EdbTask, Long>, JpaSpecificationExecutor<EdbTask> {
	
	
	@Query("select et from EdbTask et where customerCode = ?1 and warehouseCode=?2 and method=?3 and status=1")
	EdbTask findTask(String customerCode,String whCode,String method);
	
	List<EdbTask> findByMethodAndStatus(String method,String status);
	
	
}
